The diagram below shows the data model for the ebs fields that are part of the FES 2 data group.
The table FES 2 mappings details the ebs: central and ebs: ontrack Hub mappings for FES fields for the FES 2 data return fields, the FES Level, the module containing the field in ebs, and any additional information about the field.
| FES Field Name | ebs Location | FES Level | ebs Module | Notes |
| Programme directory number | Curriculum > General Tab > Programme Directory Number | 2 | UI | Generated by combining the Programme directory ID, Programme directory number, and the Year of course. For example, the programme directory ID FK, programme directory number 505678, and year of course 25, to create the programme directory number FK50567825. |
| Surname | Learner Details > Personal information > Surname | Not applicable | Learner | None |
| Name(s) | Learner Details > Personal information > Forename | Not applicable | Learner | None |
| Student matriculation number | Person code | Not applicable | Learner | None |
| SQA candidate number | Learner Details > Personal information > SQA candidate number | Not applicable | Learner | None |
| Student date of birth | Learner Details > Personal information > Date of Birth | Not applicable | Learner | None |
| Sex of student | Learner Details > Personal information > Sex | Not applicable | Learner | None |
| Gender Identity of student | Learner Details > Personal information > Gender ID | Not applicable | Learner | None |
| Nationality of student | Not applicable | Not applicable | Not applicable | Not applicable |
| Permanent home location of student | Learner Details > Address information > Domicile | Not applicable | Learner | Where Wales or Northern Ireland has been selected return Domicile Category where another other domicile category take the codes from what's been selected in the Domicile subcatgory |
| Post code of permanent home location (pre-study domicile of student) | Learner Details > Address information > Postcode | Not applicable | Learner | None |
| Student’s main campus of study | Reference Data > Study Locations > Campus Reference | 1 | UIO | Taken from study location, at FES level 1, UIO and return the corresponding site code set up in reference data. |
| Source of finance of fee for student | Enrolment details tab> Source of finance of fee for student | 2 | UIO | None |
| Ethnic group | Learner Other Details > Ethnicity | Not applicable | Learner | None |
| Mode of attendance of student | Learner > Enrolments > Special Details > Mode of Attendance | 2 | Enrolment | None |
| Qualification aim of student | Learner > Enrolments > Special Details > Qualification Aim of Student | 2 | Enrolment | None |
| Category of student | Learner Details > Other Details > Category of Student | Not applicable | Learner | None |
| School code number | Learner Details > Other Details > School Code | Not applicable | Learner | None |
| Disability allowance | Learner Details > Learner Support Needs > Disability Allowance | Not applicable | Learner | None |
| Student outcome | Search Learner > Enrolment details tab> Progress Code | 2 | Enrolment | To get the FES progress code, take the progress code and check the mapping in progress code data |
| Number of Highers at A-C | Learner Details > Other details > Number of Highers at A-C | Not applicable | Learner | None |
| Number of A-levels at A-E | Learner Details > Other details > Number of A-levels at A-E | Not applicable | Learner | None |
| Number of other Nationals, Standard Grade, SCE, GCSE at 1-3 or A-C | Learner Details > Other details > Number of other Nationals, Standard Grade, SCE, GCSE at 1-3 or A-C | Not applicable | Learner | None |
| Number of other Nationals, Standard Grade, SCE, GCSE at 4-5 or D-E | Learner Details > Other details > Number of other Nationals, Standard Grade, SCE, GCSE at 4-5 or D-E | Not applicable | Learner | None |
| Number of National Units | Learner Details > Other details > Number of National Units | Not applicable | Learner | None |
| Other qualifications | Learner Details > Other details > Other qualifications | Not applicable | Learner | None |
| SCQF Level code | Not applicable | Not applicable | Not applicable | Not used, column present in output files for data formatting requirements. |
| SQA group award | Not applicable | Not applicable | Not applicable | Not used, column present in output files for data formatting requirements. |
| Student follow up survey opt out | Not applicable | Not applicable | Not applicable | Not used, column present in output files for data formatting requirements. |
| Do you have a disability | Ontrack > Update Learner details > Disability tab > Do you have a disability | Not applicable | Learner | None |
| Learning difficulty (a specific learning condition that affects the way you learn and process information) | Ontrack > Update Learner details > Disability tab > Learning Difficulty | Not applicable | Learner | None |
| Developmental disorder (a condition that you have had since childhood which affects motor, cognitive, social and emotional skills, and speech and language) | Ontrack > Update Learner details > Disability tab > Developmental disorder | Not applicable | Learner | None |
| Long-term illness, disease or condition (a condition, not listed above, that you may have for life, which may be managed with treatment or medication) | Ontrack > Update Learner details > Disability tab > Long-term illness, disease or condition | Not applicable | Learner | None |
| Mental health condition (a condition that affects your emotional, physical and mental wellbeing) | Ontrack > Update Learner details > Disability tab > Mental health condition | Not applicable | Learner | None |
| Physical disability (a condition that substantially limits one or more basic physical activities such as walking, climbing stairs, lifting or carrying) | Ontrack > Update Learner details > Disability tab > Physical Disability | Not applicable | Learner | None |
| Deafness or partial hearing loss | Ontrack > Update Learner details > Disability tab > Deafness or partial hearing loss | Not applicable | Learner | None |
| Blindness or partial sight loss | Ontrack > Update Learner details > Disability tab > Blindness or partial sight loss | Not applicable | Learner | None |
| A disability impairment or medical condition that is not listed above | Not applicable | Not applicable | Not applicable | Not used, column present in output files for data formatting requirements. |
| Learning disability (a condition that you have had since childhood that affects the way you learn, understand information and communicate) | Ontrack > Update Learner details > Disability tab > Learning Disability | Not applicable | Learner | None |
| Planned Credits | Enrolment > Special details > Planned Credits | 2 | Enrolment | None |
| Planned Credits equivalent | Enrolment > Special details > Planned Credits Equivalent | 2 | Enrolment | None |
| Start date of student | Curriculum > Summary Tab > Start Date | 2 | UIO | None |
| End date of student | Curriculum > Summary Tab > End Date | 2 | UIO | None |
| Funding Qualifying date of student | Curriculum > Summary Tab > Funding Qualifying date | 2 | UIO | None |
| Enrolment number | Enrolment > Enrolment Details > Enrolment number | 2 | Enrolment | None |
| Tariff SUMs | Enrolment > Special details > Tariff Credits | 2 | Enrolment | None |
| Target Group | Enrolments > work placement> Target group | 2 | Work placement | None |
| ESF student status prior to enrolling in college | Not applicable | Not applicable | Not applicable | Not used, column present in output files for data formatting requirements. |
| ESF student qualification level held on entry (SCQF or equivalent level). | Not applicable | Not applicable | Not applicable | Not used, column present in output files for data formatting requirements. |
| Groups of specific interest | Ontrack Learner > Other Details > Groups of specific interest | Not applicable | Learner | None |
| Maintenance group 1 | Not applicable | Not applicable | Not applicable | Not used, column present in output files for data formatting requirements. |
| Maintenance group 2 | Not applicable | Not applicable | Not applicable | Not used, column present in output files for data formatting requirements. |
| Educational Maintenance Allowance (EMA) | Not applicable | Not applicable | Not applicable | Not used, column present in output files for data formatting requirements. |
| Award assessment category (AAC) | Enrolment > Support Funding Tab > Award assessment category | Not applicable | Enrolment | None |
| Maintenance costs | Enrolment > Support Funding Tab > Maintenance costs | Not applicable | Enrolment | None |
| Dependents allowance | Enrolment > Support Funding Tab > Dependents allowance | Not applicable | Enrolment | None |
| Study expenses allowance | Enrolment > Support Funding Tab > Study expenses allowance | Not applicable | Enrolment | None |
| Travel expenses allowance | Enrolment > Support Funding Tab > Travel expenses allowance | Not applicable | Enrolment | None |
| Special educational needs allowance | Enrolment > Support Funding Tab > Special educational needs | Not applicable | Enrolment | None |
| Total bursary expenditure | Enrolment > Support Funding Tab | Not applicable | Enrolment | Total amount awarded to the student from the bursary fund; Maintenance (bursary) costs + Accommodation & Personal Residence costs + Dependents allowance + Study expenses + Travel expenses + Special Educational Needs allowance (in whole £s). |
| Total FE discretionary fund expenditure | Enrolment > Support Funding Tab > Total FE discretionary fund expenditure | Not applicable | Enrolment | None |
| Childcare, lone parent award | Enrolment > Support Funding Tab > Childcare, lone parent award | Not applicable | Enrolment | None |
| Childcare, other award | Enrolment > Support Funding Tab > Childcare, other award field | Not applicable | Enrolment | None |
| Household income | Enrolment > Support Funding Tab > Household income | Not applicable | Enrolment | None |
| Sexual orientation | Learner > Other Details | Not applicable | Learner | None |
| Religion | Learner > Other Details | Not applicable | Learner | None |
| Carer | Ontrack > Update learner details > Other details > Is Carer | Not applicable | Learner | None |
| Caring responsibilities | Ontrack > Update learner details > Other details > Caring Responsibilities | Not applicable | Learner | Only applicable if the learner is also a carer. |
| Associate Student status | Ontrack > Learner > Other Details > Associate Student status | Not applicable | Learner | None |
| Text | Enrolment > Entrolment details tab > Text | Not applicable | Enrolment | None |
| Trans status of student | Ontrack > Learner > Other Details > Trans status of student | Not applicable | Learner | None |
| Student nationality | Learner > Other Details > Nationality | Not applicable | Learner | None |
| Marriage/civil partnership status | Not applicable | Not applicable | Not applicable | None |
| Pregnancy and maternity | Learner > Other Details | Not applicable | Learner | None |
| First or preferred language | Learner > Other Details | Not applicable | Learner | None |
| Care-experienced | Learner > Other Details | Not applicable | Learner | None |
| In receipt of care-experienced bursary | Learner > Other Details | Not applicable | Learner | None |
| Standard Industrial Classification (SIC) code | Learner > Other Details | Not applicable | Learner | None |
| Standard Occupational Classification (SOC) code | Curriculum > FES Tab > Standard Occupational Classification (SOC) | 2 | UI | None |
| Approved accommodation or lodgings residence costs | Enrolment > Support Funding Tab | Not applicable | Enrolment | None |
| Personal allowance residence costs | Enrolment > Support Funding Tab | Not applicable | Enrolment | None |
| Service student | Learner > Other Details | Not applicable | Learner | None |
| Types of care setting | Learner > Other Details | Not applicable | Learner | None |
| Academic issues | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Caring responsibilities | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Deceased | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Digital accessibility issues | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Dissatisfied with blended learning / on-line learning experience | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Dissatisfied with course / content | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Disciplinary / Exclusion | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Employer / Sponsor withdrew support | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Estranged / homelessness | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Financial issues | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Health issues | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Non-attendance / college withdrew | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| To take up employment | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Travel issues | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Unknown | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Foundation Apprentice work placement employer | Enrolments > work placement tab | 2 | Work placement | None |
| Foundation Apprentice work placement employer location post code | Enrolments > work placement tab | 2 | Work placement | None |
| Took up course offer at another institution (college or university) | Enrolments > Reason for withdrawals | 2 | Enrolment | None |
| Full or partial loss of voice or difficulty speaking (a condition that requires you to use equipment to speak) | Ontrack > Update Learner details > Disability tab | Not applicable | Learner | None |
| Foundation Apprentice email address | Learner Details, Personal information | Not applicable | Learner | Sourced from college email. |
| Employer contact name | Enrolments > work placement tab | 2 | Work placement | None |
| Employer street name | Enrolments > work placement tab | 2 | Work placement | None |
| Employer city | Enrolments > work placement tab | 2 | Work placement | None |